Index Scan
Short Description
The Index Scan node returns a row or a set of matching rows from an index
Detailed Description​
The Index Scan node returns a row or a set of matching rows from an index. If there are columns required by the query that are not in the index, a visit to the table will be required also, which can make Index Scans relatively expensive. They are usually used for single row fetches.
Additional Links​
- PostgreSQL Documentation - Using Explain
- pgAnalyze - Explain
- eTutorials - Understanding How PostgreSQL Executes a Query
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.